| /Location_Data/Contact_Data/Address_Data(@Effective_Date) Note: If Inactive is set to true, Check for any date time translations | Close Date | DATE | Date the location closed or went out of service |
| /Location_Data/Location_Name | Description | TEXT(255) | A brief description of the location |
| If upper(/Location_Data/Location_Usage_Reference/ID(@type='Location_Usage_ID)='MOBILE' then true else false. Note: This type of location usage does not exist in workday test tenant. Externalize the parameter - Location_Usage_ID and MOBILE as values may differ from customer to customer | Is Mobile | CHECKBOX | Indicates whether the location moves. For example, a truck or tool box. |
| Longitude | Longitude | GEOLOCATION | The geographic location |
| Latitude | Latitude | GEOLOCATION | The geographic location |
| /Location_Data/Location_Usage_Reference/ID(@type='Location_Usage_ID) Note: Externalize the parameter - Location_Usage_ID as it may differ from customer to customer. (May use locationmappings.csv for mapping conversion from Workday to Salesforce for Location Type) | Location Type | PICKLIST | "Work location type - Building (default), Warehouse, Site, Plant, Store, Campus, Floor, Space |
| /Location_Data/Location_ID | Location Name | TEXT (NAME) | Location_ID in Workday |
| /Location_Data/Contact_Data/Address_Data(@Effective_Date) Note: If Inactive is set to false | Open Date | DATE | Open day of the Location |
| Note: In order to achieve hierarchical relationship within a location object. We have to process Workday Data in two steps to migrate it successfully to Salesforce. Step-1: We have to do a flat load of location data into salesforce without parent location. And also, store LocationId and its Superior_Location_Reference/ID (@type=Location_ID) into Object Store for all retrieved records of a page. Step2: Fetch Object Store for the batch of locations and get Salesforce Ids of Superior Location Reference IDs and update the locations object with parent location. See Employee Migration for a reference | Parent Location ID | LOOKUP(Location__c) | For building the hierarchical relationship within a location object |
| Note: There is a Master-Child Relationship between Address and Location Objects in SFDC | VisitorAddressId | LOOKUP(Address__c) | Master-Child Relationship between Address and Location Objects in SFDC |